1. Look at the marks first, then work out how long it is worth spending on each section:

You do not lose marks for wrong answers, so attempt every question.

2. Pseudocode

• Write BEGIN and END on every algorithm or module
•    → Indent consistently
• IF remember to use THEN and ENDIF
• WHILE remember to use ENDWHILE
• IF and WHILE only execute when TRUE
• Use your left index finger to point (program flow)
• Draw up 2 tables with right hand – one variables, one output
• Modular algorithms, parameter passing & return values
• GLOBAL vs LOCAL variables (scope)

3. SQL

SELECT aggregate(x.field) AS alias
FROM x INNER JOIN y on x.field == y.field
WHERE x.field<val1 AND filter2 OR filter3
GROUP BY aggregate(y.field)
HAVING y.field>val2 ...
ORDER BY x.col1 ASC, y.col2 DESC

If you see CREATE, INSERT, DELETE or UPADTE, don't panic - think back to past assignments.

4. Block cipher shifts

• MOD (%) wraps everything
• write the word mod when using in pseudocode
• base 26 system:
  • 28 mod 26 == 2 (shift A forward 28 spaces will get me to C)
  • -24 mod 26 == 2 (shift A backward 24 spaces will get me to C)
• Works same for base 10 system:
  • 11 mod 10 == 1 (shift 0 forward 11 spaces will get me to 1)
  • -9 mod 10 == 1 (shift 0 backward 9 spaces will get me to 1)
• Preserving case, space and grammar creates patterns in ciphertext that make it weaker

5. Expect the unexpected

ALTER TABLE Students
          ADD FOREIGN KEY (StudentID)
          REFERENCES Medical(StudentID)
          ON DELETE RESTRICT
          ON UPDATE CASCADE;

READ ALL SLIDESHOWS AND COMPLETE ALL EXAM PRACTISE ACTIVITIES

Deal with the unexpected by being strategic & problem solving. Content may appear from year 11, past assignments or unfamiliar sources. You are a Digital Solutions student, so find a solution.